CREATE PROCEDURE [dbo].[responses_delete]
@responseId int

AS

DELETE FROM Comments
WHERE Comments.CommentId = @responseId

DELETE FROM [dbo].[Responses]

WHERE
    Responses.[ResponseId]=@responseId
RETURN 0
